package member;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

import db.dbMNG;

public class createMNG {
	
	dbMNG db = new dbMNG();
	Statement stmt = null;
	Connection conn = null;
	PreparedStatement pstmt = null;
	ResultSet rs = null;
	String sql;

	public void createMember(String Name, String ID, String Pwd, String Birthday, String Phone, String Mail, String chk01, String chk02, String sex)throws Exception{
		

		conn = db.getConn();  //접속

		

		stmt = conn.createStatement();
		sql = "insert into nogada(NAME, ID, PW, Birthday, phone, usermail, check01, check02, sex)values('"+ Name +"','" + ID + "','" + Pwd + "','" + Birthday + "','" + Phone + "','" + Mail + "','" + chk01 + "','" + chk02 + "','" + sex + "')";
		stmt.executeUpdate(sql);
		
		

		db.disConn();  //접속 종료

	
		
	}
}
